USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[EngineeringInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.EngineeringInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Engineering Table Insert
-- =============================================
CREATE PROCEDURE EngineeringInsert

           @EngineeringID int,
           @BuiltTime datetime,
           @ObjectId int,
           @RoundId int,
           @MiniRoundId int,
           @MapId int,
           @LogId int,
           @DateTime datetime,
           @Pos_x float,
           @Pos_y float,
           @Pos_z float
	

AS
BEGIN

INSERT INTO [Engineering]
           ([EngineeringID]
           ,[BuiltTime]
           ,[ObjectId]
           ,[RoundId]
           ,[MiniRoundId]
           ,[MapId]
           ,[LogId]
           ,[DateTime]
           ,[Pos_x]
           ,[Pos_y]
           ,[Pos_z])
     VALUES
           (@EngineeringID,
           @BuiltTime,
           @ObjectId,
           @RoundId,
           @MiniRoundId,
           @MapId,
           @LogId,
           @DateTime,
           @Pos_x,
           @Pos_y,
           @Pos_z )
END
GO
